package me.zhengjie.modules.equipment.repository;

import me.zhengjie.modules.equipment.domain.TSparepartRetrieval;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
* @author jie
* @date 2019-11-16
*/
public interface TSparepartRetrievalRepository extends JpaRepository<TSparepartRetrieval, Integer>, JpaSpecificationExecutor {

    @Query("select t from TSparepartRetrieval t where t.eqptId = ?1")
    List<TSparepartRetrieval> listBySparepartId(Integer sparepartId) ;
}